import xlrd
from xlutils.copy import copy

# 打开Excel文件
workbook = xlrd.open_workbook('test.xlsx')
# 进行复制处理
new_workbook = copy(workbook)
# 调取表格信息
sheet = workbook.sheet_by_index(0)
col = sheet.col_values(0) #获取第一列数据
# print(col)
cel_val = sheet.cell_value(0, 0) #获取第一行第一列数据
# print(cel_val)

# 写入表格信息
sheet_write = new_workbook.get_sheet(0)
sheet_write.write(0, 1, '追加内容')

new_workbook.save('test_copy2.xls')